Course: Microsoft Power BI Training
Topic: Creating Tables and Matrix Visualizations
Course Link: Microsoft Power BI Training at JustAcademy
Demo Link: Register for a Course Demo
JustAcademy Website: Visit JustAcademy
Microsoft Power BI provides several visualization options for presenting business data in a structured and understandable format. Tables and matrix visualizations are especially useful when users need to view exact values, compare multiple measures, analyze categories, and examine summarized information.
A table displays information in rows and columns, similar to a spreadsheet. A matrix organizes information across multiple dimensions, allowing users to group data, expand or collapse hierarchies, and analyze subtotals and totals.
These visualizations are commonly used in sales reports, financial statements, inventory analysis, employee performance reports, customer analytics, and business dashboards.
A table visual displays related information in a grid consisting of rows and columns. Each row represents a record or category, while each column represents a field or measure.
Tables are useful when users need to see exact numerical values rather than only visual comparisons.
Consider a company that wants to analyze product sales.
| Product | Category | Region | Quantity | Sales |
|---|---|---|---|---|
| Laptop | Electronics | North | 5 | 250000 |
| Mobile | Electronics | South | 10 | 180000 |
| Office Chair | Furniture | West | 8 | 64000 |
| Monitor | Electronics | North | 6 | 90000 |
| Office Desk | Furniture | South | 4 | 48000 |
This table allows users to inspect product names, categories, regions, quantities, and sales values in one place.
A matrix visual organizes data across multiple dimensions. It is similar to a PivotTable in Microsoft Excel because it can group data into row and column hierarchies and calculate aggregated values at different levels.
Unlike a basic table, a matrix can place one category on rows and another category on columns, producing a cross-tabulated summary.
Suppose a business wants to compare sales by region and product category.
| Region | Electronics | Furniture | Total Sales |
|---|---|---|---|
| North | 340000 | 75000 | 415000 |
| South | 180000 | 120000 | 300000 |
| West | 210000 | 95000 | 305000 |
| Grand Total | 730000 | 290000 | 1020000 |
The matrix shows each region's contribution to Electronics and Furniture sales. It also provides row totals and an overall grand total.
| Feature | Table Visual | Matrix Visual |
|---|---|---|
| Structure | Simple rows and columns | Rows, columns, and grouped dimensions |
| Primary purpose | Detailed data display | Summarization and multidimensional analysis |
| Row hierarchy | No native expandable hierarchy like a matrix | Supports hierarchical row groups |
| Column hierarchy | Displays fields as columns | Supports hierarchical column groups |
| Subtotals | Generally provides a total row | Supports row and column subtotals |
| Grand totals | Can display totals for appropriate fields | Can display row, column, and grand totals |
| Best suited for | Records and exact values | Grouped summaries and cross-tabulation |
| Typical example | Customer transaction list | Sales by region and category |
Before building a table or matrix, ensure that your dataset contains the required fields and that each field has the correct data type.
Use a dataset named SalesData with the following columns:
| OrderID | OrderDate | Region | Category | Product | Quantity | Sales |
|---|---|---|---|---|---|---|
| 1001 | 2026-01-05 | North | Electronics | Laptop | 2 | 100000 |
| 1002 | 2026-01-08 | South | Electronics | Mobile | 3 | 54000 |
| 1003 | 2026-02-12 | West | Furniture | Chair | 4 | 32000 |
| 1004 | 2026-02-20 | North | Electronics | Monitor | 2 | 30000 |
| 1005 | 2026-03-15 | South | Furniture | Desk | 1 | 12000 |
| 1006 | 2026-03-20 | West | Electronics | Laptop | 1 | 50000 |
Follow these steps to create a table visual in Power BI Desktop.
Launch Power BI Desktop and open an existing report or create a new report.
In the Visualizations pane, select the Table visual icon. Power BI places an empty table on the report canvas. The exact selection controls may vary depending on the Power BI interface version.
From the Data or Fields pane, select or drag the required fields into the table's Columns field well or equivalent build area.
For example, add:
Power BI displays the selected fields as columns in the table visual.
Reorder the fields to present information logically. A useful order is OrderID, OrderDate, Region, Product, Quantity, and Sales.
Power BI may summarize numerical columns by Sum, Count, or another aggregation, depending on the field and its settings. For transaction-level data, you may need to display individual values. For category-level reporting, you may prefer summed sales and quantities.
Check the summarization options for each numerical field. Use a unique transaction identifier when you need to distinguish individual records.
Select the table and open the Format visual pane. Depending on the version and visual, you can configure:
Set a meaningful title, such as Sales Transaction Details, to explain what the table contains.
Compare the displayed data with the source dataset. Check that column values, row counts, and numerical aggregations are correct.
A matrix visual is particularly useful when you want to summarize data across row and column categories.
In the Visualizations pane, select the Matrix visual icon. An empty matrix appears on the report canvas.
Drag a field such as Region into the Rows area. Each region becomes a separate row group.
You can add more than one field to Rows to create a hierarchy. For example:
This hierarchy can allow users to analyze sales from a broad regional level down to individual products.
Drag a field such as Category into the Columns area. Power BI creates separate column groups for each category.
You can add additional column fields if you need a more detailed column hierarchy. However, too many fields can make the matrix difficult to read.
Drag Sales into the Values area. Power BI calculates the sales values for the relevant combinations of row and column categories.
You can add additional measures such as Quantity, Profit, and Order Count to the Values area.
The matrix should now display regions as rows, categories as columns, and sales as values. If subtotals and grand totals are enabled, they summarize the data at the corresponding levels.
Use the Format visual pane to customize row headers, column headers, values, gridlines, subtotals, grand totals, column widths, and the matrix layout.
If multiple fields are used in Rows or Columns, test the expand and collapse controls to verify that users can move between summary and detail levels.
The matrix field areas control how data is organized and summarized.
| Field Area | Purpose | Example |
|---|---|---|
| Rows | Defines categories shown vertically. | Region, Department, Product |
| Columns | Defines categories displayed horizontally. | Category, Year, Quarter |
| Values | Contains numerical fields or measures to aggregate. | Total Sales, Quantity, Profit |
To analyze sales by region and product category:
To analyze sales by year, quarter, and region:
DAX measures allow you to calculate business metrics that respond to filters and the grouping structure of your visualizations.
Total Sales = SUM(SalesData[Sales])This measure adds the sales values within the current filter context.
Total Quantity = SUM(SalesData[Quantity])This measure calculates the total quantity sold.
Total Orders = DISTINCTCOUNT(SalesData[OrderID])This measure counts unique order identifiers. It is useful when one order can contain multiple transaction rows.
Average Sales per Row = AVERAGE(SalesData[Sales])This measure calculates the average value of the Sales column across the rows included in the current filter context. It does not necessarily represent average sales per order if an order contains multiple rows.
If the dataset includes a Profit column, create the following measure:
Total Profit = SUM(SalesData[Profit])If profit is not provided, you must calculate it from appropriate cost and revenue fields before using this measure.
Aggregation is the process of combining multiple data values into a summarized result. In a matrix, Power BI evaluates the selected measure for each combination of row and column categories.
If North region Electronics sales are 100,000, 50,000, and 30,000, the total sales for that category and region are:
Total Sales = 100000 + 50000 + 30000
Total Sales = 180000The matrix displays 180,000 at the intersection of North and Electronics when the measure and filter context are configured correctly.
A DAX measure's grand total is generally recalculated in the grand-total filter context. It is not always the arithmetic sum of the values displayed in individual rows. This distinction matters for ratios, averages, percentages, and other non-additive measures.
Professional formatting improves readability and makes important information easier to find.
Adjust column widths to prevent important information from being cut off. Use auto-sizing where appropriate, or set widths manually for a more consistent layout.
Gridlines can help users follow values across a row. Use subtle lines and avoid excessive borders that distract from the information.
Alternating row backgrounds, sometimes called banded rows, make wide tables easier to scan. Use a restrained style so that the values remain the main focus.
Enable totals where a summary is useful. Confirm that the total calculation makes business sense for each numerical field.
Matrix visuals provide additional formatting controls because they support grouped rows and columns.
Customize row-header font, text color, background color, alignment, and wrapping. Keep hierarchical labels readable at every level.
Format column labels to make category groups easy to identify. Long headers may require wrapping or a wider visual.
Apply suitable number formats, decimal places, display units, and alignment to the values area.
Power BI matrix visuals offer layout options that can vary with the interface version. Common layout choices include:
Choose the layout that makes the hierarchy easiest for your report users to understand.
Adjust widths to fit labels and values. When a matrix contains many columns, consider using suitable widths and keeping row headers visible while users scroll horizontally.
Freezing row headers can help users identify the current row while scrolling across a wide matrix. The exact setting is available in the matrix formatting options in supported Power BI interfaces.
Totals and subtotals help summarize data at different hierarchy levels.
A grand total summarizes values across the relevant categories and filter context. For example, a sales matrix may display the total sales across all regions and product categories.
Row subtotals summarize values for a row group. If Region is the first row level and Product is the second, the subtotal can show the total for each region.
Column subtotals summarize data within a column hierarchy. They are useful when columns contain multiple levels, such as Year and Quarter.
Tables and matrices have different subtotal capabilities. A table generally provides a total row, while a matrix supports subtotals for grouped row and column hierarchies.
In supported versions of Power BI, custom totals can change the calculation shown in a numerical total cell, including options such as Sum, Average, Minimum, Maximum, Count, Distinct Count, or None. Availability and behavior depend on the visual and Power BI feature support.
Conditional formatting changes the appearance of values according to their data or defined rules. It helps users identify high values, low values, exceptions, and performance indicators without examining every number individually.
Background color formatting changes a cell's background based on its value or a configured rule.
Example: Higher sales values can receive a stronger background shade than lower values.
Font color formatting changes the text color according to business rules.
Example: Positive profit values can use a different font color from negative profit values.
Data bars display bars inside table or matrix cells to represent numerical magnitude. They help users compare values while retaining the numerical information.
Icons can represent performance status, direction, or threshold categories.
Always define the business rules before assigning icons so that users interpret the indicators correctly.
A hierarchy organizes related categories into levels. Matrix visuals can use hierarchies to move from summary information to more detailed information.
Users can begin with category-level sales, expand a category to view subcategories, and then expand a subcategory to view individual products.
This hierarchy allows users to analyze annual sales, quarterly performance, monthly trends, and daily details.
Sorting and filtering allow users to focus on relevant data and arrange information in a useful order.
Users can sort by suitable columns or measures, depending on the visual and available options.
Visual-level filters affect the selected visual. For example, a table can display only orders from a particular region while other visuals remain unchanged.
Page-level filters affect the visuals on a report page that are subject to those filters. For example, a page can focus on sales from 2026.
Report-level filters apply across the report according to the filter configuration. They are useful when a report should consistently focus on a specific year, region, or business unit.
Slicers are interactive report controls that let users filter data by selecting values such as Region, Category, Year, or Product.
Filter context determines which rows of data are considered when Power BI calculates a measure. Each matrix cell can have its own filter context based on the row category, column category, slicers, page filters, and report filters.
Suppose the matrix has Region in Rows, Category in Columns, and Total Sales in Values. The cell at North and Electronics calculates Total Sales for records that match North and Electronics, along with any other active filters.
Total Sales = SUM(SalesData[Sales])The same measure can produce different values for North, South, Electronics, Furniture, and the grand total because the filter context changes.
In this project, you will build a Power BI report that contains a detailed table and a summarized matrix.
Total Sales = SUM(SalesData[Sales])
Total Quantity = SUM(SalesData[Quantity])
Total Orders = DISTINCTCOUNT(SalesData[OrderID])Add Total Quantity or Total Orders to the matrix Values area if these measures help explain the sales performance.
Apply background colors or data bars to the Total Sales values. Use a consistent formatting rule that makes high and low values easy to distinguish.
The final report should allow users to review individual sales records in the table and analyze summarized sales performance across regions and product categories in the matrix.
Problem: The visual counts values rather than adding them.
Possible causes: The field may be stored as text, or its summarization setting may be set to Count.
Solution:
Problem: The grand total does not equal the sum of the visible values.
Possible causes: The measure is non-additive, the filter context differs, or the data model contains unexpected relationships.
Solution: Review the DAX measure, inspect the underlying records, verify model relationships, and confirm whether the total should be recalculated or should represent the sum of displayed rows.
Problem: Certain products, regions, or categories do not appear.
Solution:
Problem: The matrix extends beyond the report canvas.
Solution: Adjust column widths, simplify labels, remove unnecessary fields, reduce the number of column hierarchy levels, or use a suitable layout.
Problem: Hierarchy labels are crowded or unclear.
Solution: Increase the visual's width, adjust text size, enable appropriate text wrapping, or choose a matrix layout that makes the hierarchy easier to follow.
Problem: Colors or icons do not reflect the intended values.
Solution: Review the selected field, formatting rules, thresholds, and calculation logic. Confirm whether the rule applies to values, subtotals, totals, or a particular series.
Problem: Selecting a slicer value does not change the expected result.
Solution: Check the data model relationships, field selection, visual interaction settings, and measure logic. Ensure that the slicer filters the table used by the matrix.
Problem: The table displays repeated-looking records.
Possible causes: The source contains duplicates, the displayed fields do not uniquely identify a record, or relationships cause unexpected results.
Solution: Inspect the underlying data and the table's fields. Include a unique transaction identifier where appropriate and remove duplicates only when they are genuinely invalid.
Large tables and matrices may take longer to render, especially when they contain many rows, columns, hierarchy levels, or complex measures.
Create a table showing OrderID, OrderDate, Region, Product, Quantity, and Sales. Format the numerical fields and adjust the column widths.
Learning outcome: Field selection, table formatting, and detailed data display.
Create a matrix with Region in Rows, Category in Columns, and Total Sales in Values.
Learning outcome: Matrix configuration, aggregation, and multidimensional analysis.
Add Category and Product to the Rows area. Practice expanding and collapsing the hierarchy.
Learning outcome: Hierarchical reporting and drill-down analysis.
Apply data bars or background color formatting to the Sales values.
Learning outcome: Identifying high and low values visually.
Configure row subtotals, column subtotals, and grand totals in a matrix. Validate the results using the underlying dataset.
Learning outcome: Understanding aggregation and summary calculations.
Combine a detailed table, a matrix, and a Region slicer on one report page. Test how each visual responds to the slicer.
Learning outcome: Report design, filtering, and interactive analysis.
A table visual displays related information in rows and columns. It is useful for reviewing detailed records and comparing exact values.
A matrix visual organizes data across multiple row and column dimensions. It supports aggregation, hierarchies, subtotals, and grand totals.
A table is primarily used to display detailed information in a flat structure. A matrix is designed for grouped summaries across multiple dimensions and supports expandable hierarchies.
Rows define vertical groups, Columns define horizontal groups, and Values contain measures or numerical fields to be calculated for each intersection.
A subtotal summarizes values within a group in a hierarchy, such as the total sales for each region.
A grand total summarizes data across the relevant categories and current filter context.
Conditional formatting changes the appearance of cells according to values or rules. It can use background colors, font colors, data bars, and icons.
A hierarchy organizes related fields into levels, such as Year, Quarter, Month, and Date. Users can expand or collapse levels to move between summary and detail.
Some DAX measures are recalculated in the grand-total filter context. Averages, ratios, distinct counts, and other non-additive calculations may therefore produce totals that differ from the arithmetic sum of displayed rows.
Use clear labels, suitable column widths, appropriate formatting, limited hierarchy levels, consistent number formats, and a layout that makes row and column groups easy to understand.
DAX measures provide reusable business calculations that respond to the matrix's row context, column context, slicers, and filters.
Use hierarchies, expand and collapse controls, slicers, report filters, and interactions with other visuals to let users explore the data.
Tables and matrix visualizations are essential tools for presenting structured information in Microsoft Power BI. Tables help users examine individual records and exact values, while matrices summarize data across multiple dimensions and support hierarchical analysis.
By learning to add fields, configure aggregations, create DAX measures, format values, apply conditional formatting, and manage totals and subtotals, you can build reports that are both informative and easy to use.
Practice creating both visuals with a real dataset and validate the results against the source data. Choose a table when detailed information is required and a matrix when grouped comparisons and multidimensional summaries provide greater value.
Continue Learning: Explore Microsoft Power BI Training | Register for a Course Demo | Visit JustAcademy
